lookup question / count question

[j4ymf]

Hello

i was woundering how do i write a query to lookup this

my range is A1:N1000

i want to count the total of G:G
where D:D = MAPK
and N:N = RED

does that make sence

Thanks jason

 

[j4ymf]

mmm

sorry to mess you about

but i changed my range from 1000 to 865 where there is data

and that works, sorry my fault

thank you once again

 

[Michael M]

No worries anytime you do SUMPRODUCTS and SUMIFS etc, you need to maintain ALL rasnges to the same length, ottherwise you will get the #N/A error !!...